import openpyxl 

def save1(sname):
  wb = openpyxl.Workbook()
  ws = wb.active
  rows = data[sname].max_row
  cols = data[sname].max_column
  print(rows,cols)
  for row in range(1,rows):
    row_data = []
    for col in range(1,cols): 
      row_data.append(data[sname][row][col].value)
    ws.append(row_data)
  wb.save('数据持久化/xlsx/'+sname+'.xlsx')

data = openpyxl.load_workbook('数据持久化\疫苗数据.xlsx')
sheets = data.sheetnames
for i in sheets:
  save1(i)

